﻿Imports System.Data.SqlClient

Public Class <OwnerU>_<TableU>ComboService<MiscTag>
    Implements I<OwnerU>_<TableU>ComboService<MiscTag>

<If Loop>
   <IsFKey>
    Public Function List<OwnerU>_<TableU>_<ROwnerU>_<RTableU><MiscTag>() As List(Of <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>) Implements I<OwnerU>_<TableU>ComboService<MiscTag>.List<OwnerU>_<TableU>_<ROwnerU>_<RTableU><MiscTag>
        Dim  <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List As New List(Of <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>)
        Dim connection As SqlConnection = <Database>DataService.GetConnection
        Dim selectProcedure As String = "[<Owner>].[<TableU>_<RTableU><MiscTag>Select]"
        Dim selectCommand As New SqlCommand(selectProcedure, connection)
        selectCommand.CommandType = CommandType.StoredProcedure
        Try
            connection.Open()
            Dim reader As SqlDataReader = selectCommand.ExecuteReader()
            Dim  cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU> As <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>
            Do While reader.Read
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU> = New <OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>
                <IsFKey>
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>.<RFieldU> = <Convert>(reader("<RField>").ToString)
                <IsFKey>
                <And>
                <IsRDisplayField>
                cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>.<RDisplayFieldU> = System.Convert.ToString(reader("<RDisplayField>").ToString)
                <IsFKey>
                <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List.Add(cls<OwnerU>_<TableU>_<ROwnerU>_<RTableU>)
            <IsFKey>
            Loop
            reader.Close()
        Catch ex As SqlException
            Throw ex
        Finally
            connection.Close()
        End Try
        Return <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List
    End Function

</If Loop>
End Class
